package com.yd.app.mapper.provider;

import com.yd.domain.business.Statistical;

import java.util.Map;

/**
 * 统计分析
 * Created by sunxianhui on 2018/3/20.
 */
public class TranslateProvider {

    /**
     * 根据客户类型获取每一页列表
     * @param map
     * @return
     */
    public String searchList(Map map) {
        Statistical statistical = (Statistical) map.get("statistical");
        StringBuilder sb = new StringBuilder("SELECT br.*,su.realName,su.userName from business_translate  br left join sys_user su on br.userId=su.id  ");
        return sb.toString();
    }

    /**
     * 根据客户类型获取查询总数量
     * @param map
     * @return
     */
    public String searchCount(Map map) {
        Statistical statistical = (Statistical) map.get("statistical");
        StringBuilder sb = new StringBuilder("select COUNT(1) FROM business_translate ");
        return sb.toString();
    }
}
